package com.xckj.dao;

import java.util.List;

import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

import com.xckj.entity.JacgMybatisMsWriteTable;

/**
 * @description MyBatis写数据库表信息（使用MySQL）
 * @author yanchf
 * @date 2023-12-03
 */
@Mapper
@Repository
public interface JacgMybatisMsWriteTableMapper {

    /**
    * 新增
    * @author yanchf
    * @date 2023/12/03
    **/
    int insert(JacgMybatisMsWriteTable jacgMybatisMsWriteTable);

    /**
    * 刪除
    * @author yanchf
    * @date 2023/12/03
    **/
    int delete(int id);

    /**
    * 更新
    * @author yanchf
    * @date 2023/12/03
    **/
    int update(JacgMybatisMsWriteTable jacgMybatisMsWriteTable);

    /**
    * 查询 根据主键 id 查询
    * @author yanchf
    * @date 2023/12/03
    **/
    JacgMybatisMsWriteTable load(int id);

    /**
    * 查询 分页查询
    * @author yanchf
    * @date 2023/12/03
    **/
    List<JacgMybatisMsWriteTable> pageList(int offset,int pagesize);

    /**
    * 查询 分页查询 count
    * @author yanchf
    * @date 2023/12/03
    **/
    int pageListCount(int offset,int pagesize);

}